Overview

Dataset statistics

Number of variables17
Number of observations21613
Missing cells0
Missing cells (%)0.0%
Duplicate rows5
Duplicate rows (%)< 0.1%
Total size in memory2.8 MiB
Average record size in memory136.0 B

Variable types

NUM16
BOOL1

Reproduction

Analysis started2020-06-12 03:24:22.393818
Analysis finished2020-06-12 03:25:27.226330
Duration1 minute and 4.83 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Dataset has 5 (< 0.1%) duplicate rows Duplicates
view has 19489 (90.2%) zeros Zeros
sqft_basement has 13126 (60.7%) zeros Zeros
age has 430 (2.0%) zeros Zeros

Variables

price
Real number (ℝ≥0)

Distinct count4028
Unique (%)18.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean540088.1417665294
Minimum75000.0
Maximum7700000.0
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum75000
5-th percentile210000
Q1321950
median450000
Q3645000
95-th percentile1156480
Maximum7700000
Range7625000
Interquartile range (IQR)323050

Descriptive statistics

Standard deviation367127.1965
Coefficient of variation (CV)0.6797542255
Kurtosis34.58554043
Mean540088.1418
Median Absolute Deviation (MAD)150000
Skewness4.024069145
Sum1.167292501e+10
Variance1.347823784e+11
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4500001720.8%
 
3500001720.8%
 
5500001590.7%
 
5000001520.7%
 
4250001500.7%
 
3250001480.7%
 
4000001450.7%
 
3750001380.6%
 
3000001330.6%
 
5250001310.6%
 
Other values (4018)2011393.1%
 
ValueCountFrequency (%) 
750001< 0.1%
 
780001< 0.1%
 
800001< 0.1%
 
810001< 0.1%
 
820001< 0.1%
 
ValueCountFrequency (%) 
77000001< 0.1%
 
70625001< 0.1%
 
68850001< 0.1%
 
55700001< 0.1%
 
53500001< 0.1%
 

bedrooms
Real number (ℝ≥0)

Distinct count13
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.37084162309721
Minimum0
Maximum33
Zeros13
Zeros (%)0.1%
Memory size168.9 KiB

Quantile statistics

Minimum0
5-th percentile2
Q13
median3
Q34
95-th percentile5
Maximum33
Range33
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.9300618311
Coefficient of variation (CV)0.2759138325
Kurtosis49.06365318
Mean3.370841623
Median Absolute Deviation (MAD)1
Skewness1.974299535
Sum72854
Variance0.8650150098
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3982445.5%
 
4688231.8%
 
2276012.8%
 
516017.4%
 
62721.3%
 
11990.9%
 
7380.2%
 
8130.1%
 
0130.1%
 
96< 0.1%
 
Other values (3)5< 0.1%
 
ValueCountFrequency (%) 
0130.1%
 
11990.9%
 
2276012.8%
 
3982445.5%
 
4688231.8%
 
ValueCountFrequency (%) 
331< 0.1%
 
111< 0.1%
 
103< 0.1%
 
96< 0.1%
 
8130.1%
 

bathrooms
Real number (ℝ≥0)

Distinct count30
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.1147573219821405
Minimum0.0
Maximum8.0
Zeros10
Zeros (%)< 0.1%
Memory size168.9 KiB

Quantile statistics

Minimum0
5-th percentile1
Q11.75
median2.25
Q32.5
95-th percentile3.5
Maximum8
Range8
Interquartile range (IQR)0.75

Descriptive statistics

Standard deviation0.7701631572
Coefficient of variation (CV)0.3641851238
Kurtosis1.279902444
Mean2.114757322
Median Absolute Deviation (MAD)0.5
Skewness0.5111075733
Sum45706.25
Variance0.5931512887
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.5538024.9%
 
1385217.8%
 
1.75304814.1%
 
2.2520479.5%
 
219308.9%
 
1.514466.7%
 
2.7511855.5%
 
37533.5%
 
3.57313.4%
 
3.255892.7%
 
Other values (20)6523.0%
 
ValueCountFrequency (%) 
010< 0.1%
 
0.54< 0.1%
 
0.75720.3%
 
1385217.8%
 
1.259< 0.1%
 
ValueCountFrequency (%) 
82< 0.1%
 
7.751< 0.1%
 
7.51< 0.1%
 
6.752< 0.1%
 
6.52< 0.1%
 

sqft_living
Real number (ℝ≥0)

Distinct count1038
Unique (%)4.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2079.8997362698374
Minimum290
Maximum13540
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum290
5-th percentile940
Q11427
median1910
Q32550
95-th percentile3760
Maximum13540
Range13250
Interquartile range (IQR)1123

Descriptive statistics

Standard deviation918.440897
Coefficient of variation (CV)0.4415794093
Kurtosis5.24309299
Mean2079.899736
Median Absolute Deviation (MAD)540
Skewness1.471555427
Sum44952873
Variance843533.6814
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
13001380.6%
 
14001350.6%
 
14401330.6%
 
10101290.6%
 
16601290.6%
 
18001290.6%
 
18201280.6%
 
14801250.6%
 
17201250.6%
 
15401240.6%
 
Other values (1028)2031894.0%
 
ValueCountFrequency (%) 
2901< 0.1%
 
3701< 0.1%
 
3801< 0.1%
 
3841< 0.1%
 
3902< 0.1%
 
ValueCountFrequency (%) 
135401< 0.1%
 
120501< 0.1%
 
100401< 0.1%
 
98901< 0.1%
 
96401< 0.1%
 

sqft_lot
Real number (ℝ≥0)

Distinct count9782
Unique (%)45.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15106.967565816869
Minimum520
Maximum1651359
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum520
5-th percentile1800
Q15040
median7618
Q310688
95-th percentile43339.2
Maximum1651359
Range1650839
Interquartile range (IQR)5648

Descriptive statistics

Standard deviation41420.51152
Coefficient of variation (CV)2.741815082
Kurtosis285.0778197
Mean15106.96757
Median Absolute Deviation (MAD)2618
Skewness13.06001896
Sum326506890
Variance1715658774
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
50003581.7%
 
60002901.3%
 
40002511.2%
 
72002201.0%
 
48001200.6%
 
75001190.6%
 
45001140.5%
 
84001110.5%
 
96001090.5%
 
36001030.5%
 
Other values (9772)1981891.7%
 
ValueCountFrequency (%) 
5201< 0.1%
 
5721< 0.1%
 
6001< 0.1%
 
6091< 0.1%
 
6351< 0.1%
 
ValueCountFrequency (%) 
16513591< 0.1%
 
11647941< 0.1%
 
10742181< 0.1%
 
10240681< 0.1%
 
9829981< 0.1%
 

floors
Real number (ℝ≥0)

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.4943089807060566
Minimum1.0
Maximum3.5
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1.5
Q32
95-th percentile2
Maximum3.5
Range2.5
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.5399888951
Coefficient of variation (CV)0.361363615
Kurtosis-0.4847229368
Mean1.494308981
Median Absolute Deviation (MAD)0.5
Skewness0.6161767212
Sum32296.5
Variance0.2915880069
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
11068049.4%
 
2824138.1%
 
1.519108.8%
 
36132.8%
 
2.51610.7%
 
3.58< 0.1%
 
ValueCountFrequency (%) 
11068049.4%
 
1.519108.8%
 
2824138.1%
 
2.51610.7%
 
36132.8%
 
ValueCountFrequency (%) 
3.58< 0.1%
 
36132.8%
 
2.51610.7%
 
2824138.1%
 
1.519108.8%
 

waterfront
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size168.9 KiB
0
21450
1
 
163
ValueCountFrequency (%) 
02145099.2%
 
11630.8%
 

view
Real number (ℝ≥0)

ZEROS

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.23430342849211122
Minimum0
Maximum4
Zeros19489
Zeros (%)90.2%
Memory size168.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile2
Maximum4
Range4
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.7663175693
Coefficient of variation (CV)3.270620384
Kurtosis10.89302168
Mean0.2343034285
Median Absolute Deviation (MAD)0
Skewness3.395749593
Sum5064
Variance0.587242617
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01948990.2%
 
29634.5%
 
35102.4%
 
13321.5%
 
43191.5%
 
ValueCountFrequency (%) 
01948990.2%
 
13321.5%
 
29634.5%
 
35102.4%
 
43191.5%
 
ValueCountFrequency (%) 
43191.5%
 
35102.4%
 
29634.5%
 
13321.5%
 
01948990.2%
 

condition
Real number (ℝ≥0)

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.4094295100171195
Minimum1
Maximum5
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum1
5-th percentile3
Q13
median3
Q34
95-th percentile5
Maximum5
Range4
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.6507430464
Coefficient of variation (CV)0.1908656696
Kurtosis0.5257635653
Mean3.40942951
Median Absolute Deviation (MAD)0
Skewness1.032804637
Sum73688
Variance0.4234665124
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
31403164.9%
 
4567926.3%
 
517017.9%
 
21720.8%
 
1300.1%
 
ValueCountFrequency (%) 
1300.1%
 
21720.8%
 
31403164.9%
 
4567926.3%
 
517017.9%
 
ValueCountFrequency (%) 
517017.9%
 
4567926.3%
 
31403164.9%
 
21720.8%
 
1300.1%
 

grade
Real number (ℝ≥0)

Distinct count12
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.656873178179799
Minimum1
Maximum13
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum1
5-th percentile6
Q17
median7
Q38
95-th percentile10
Maximum13
Range12
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.175458757
Coefficient of variation (CV)0.1535168116
Kurtosis1.190932077
Mean7.656873178
Median Absolute Deviation (MAD)1
Skewness0.7711032008
Sum165488
Variance1.381703289
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7898141.6%
 
8606828.1%
 
9261512.1%
 
620389.4%
 
1011345.2%
 
113991.8%
 
52421.1%
 
12900.4%
 
4290.1%
 
13130.1%
 
Other values (2)4< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
33< 0.1%
 
4290.1%
 
52421.1%
 
620389.4%
 
ValueCountFrequency (%) 
13130.1%
 
12900.4%
 
113991.8%
 
1011345.2%
 
9261512.1%
 

sqft_above
Real number (ℝ≥0)

Distinct count946
Unique (%)4.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1788.3906907879516
Minimum290
Maximum9410
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum290
5-th percentile850
Q11190
median1560
Q32210
95-th percentile3400
Maximum9410
Range9120
Interquartile range (IQR)1020

Descriptive statistics

Standard deviation828.0909777
Coefficient of variation (CV)0.4630369538
Kurtosis3.402303621
Mean1788.390691
Median Absolute Deviation (MAD)450
Skewness1.446664473
Sum38652488
Variance685734.6673
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
13002121.0%
 
10102101.0%
 
12002061.0%
 
12201920.9%
 
11401840.9%
 
14001800.8%
 
10601780.8%
 
11801770.8%
 
13401760.8%
 
12501740.8%
 
Other values (936)1972491.3%
 
ValueCountFrequency (%) 
2901< 0.1%
 
3701< 0.1%
 
3801< 0.1%
 
3841< 0.1%
 
3902< 0.1%
 
ValueCountFrequency (%) 
94101< 0.1%
 
88601< 0.1%
 
85701< 0.1%
 
80201< 0.1%
 
78801< 0.1%
 

sqft_basement
Real number (ℝ≥0)

ZEROS

Distinct count306
Unique (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean291.5090454818859
Minimum0
Maximum4820
Zeros13126
Zeros (%)60.7%
Memory size168.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q3560
95-th percentile1190
Maximum4820
Range4820
Interquartile range (IQR)560

Descriptive statistics

Standard deviation442.5750427
Coefficient of variation (CV)1.518220616
Kurtosis2.715574211
Mean291.5090455
Median Absolute Deviation (MAD)0
Skewness1.577965056
Sum6300385
Variance195872.6684
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01312660.7%
 
6002211.0%
 
7002181.0%
 
5002141.0%
 
8002061.0%
 
4001840.9%
 
10001490.7%
 
9001440.7%
 
3001420.7%
 
2001080.5%
 
Other values (296)690131.9%
 
ValueCountFrequency (%) 
01312660.7%
 
102< 0.1%
 
201< 0.1%
 
404< 0.1%
 
50110.1%
 
ValueCountFrequency (%) 
48201< 0.1%
 
41301< 0.1%
 
35001< 0.1%
 
34801< 0.1%
 
32601< 0.1%
 

lat
Real number (ℝ≥0)

Distinct count5034
Unique (%)23.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean47.56005251931708
Minimum47.1559
Maximum47.7776
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum47.1559
5-th percentile47.3103
Q147.471
median47.5718
Q347.678
95-th percentile47.74964
Maximum47.7776
Range0.6217
Interquartile range (IQR)0.207

Descriptive statistics

Standard deviation0.1385637102
Coefficient of variation (CV)0.002913447377
Kurtosis-0.6763130016
Mean47.56005252
Median Absolute Deviation (MAD)0.1049
Skewness-0.4852704765
Sum1027915.415
Variance0.0191999018
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
47.5491170.1%
 
47.6846170.1%
 
47.6624170.1%
 
47.5322170.1%
 
47.6711160.1%
 
47.6886160.1%
 
47.6955160.1%
 
47.686150.1%
 
47.6647150.1%
 
47.6904150.1%
 
Other values (5024)2145299.3%
 
ValueCountFrequency (%) 
47.15591< 0.1%
 
47.15931< 0.1%
 
47.16221< 0.1%
 
47.16471< 0.1%
 
47.17641< 0.1%
 
ValueCountFrequency (%) 
47.77763< 0.1%
 
47.77753< 0.1%
 
47.77741< 0.1%
 
47.77723< 0.1%
 
47.77712< 0.1%
 

long
Real number (ℝ)

Distinct count752
Unique (%)3.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-122.21389640494147
Minimum-122.51899999999999
Maximum-121.315
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum-122.519
5-th percentile-122.387
Q1-122.328
median-122.23
Q3-122.125
95-th percentile-121.979
Maximum-121.315
Range1.204
Interquartile range (IQR)0.203

Descriptive statistics

Standard deviation0.1408283424
Coefficient of variation (CV)-0.001152310388
Kurtosis1.049500887
Mean-122.2138964
Median Absolute Deviation (MAD)0.101
Skewness0.8850529834
Sum-2641408.943
Variance0.01983262202
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-122.291160.5%
 
-122.31110.5%
 
-122.3621040.5%
 
-122.2911000.5%
 
-122.372990.5%
 
-122.363990.5%
 
-122.288980.5%
 
-122.357960.4%
 
-122.284950.4%
 
-122.365940.4%
 
Other values (742)2060195.3%
 
ValueCountFrequency (%) 
-122.5191< 0.1%
 
-122.5151< 0.1%
 
-122.5141< 0.1%
 
-122.5121< 0.1%
 
-122.5112< 0.1%
 
ValueCountFrequency (%) 
-121.3152< 0.1%
 
-121.3161< 0.1%
 
-121.3191< 0.1%
 
-121.3211< 0.1%
 
-121.3251< 0.1%
 

sqft_living15
Real number (ℝ≥0)

Distinct count777
Unique (%)3.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1986.552491556008
Minimum399
Maximum6210
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum399
5-th percentile1140
Q11490
median1840
Q32360
95-th percentile3300
Maximum6210
Range5811
Interquartile range (IQR)870

Descriptive statistics

Standard deviation685.3913043
Coefficient of variation (CV)0.3450154512
Kurtosis1.59709581
Mean1986.552492
Median Absolute Deviation (MAD)410
Skewness1.108181276
Sum42935359
Variance469761.2399
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
15401970.9%
 
14401950.9%
 
15601920.9%
 
15001810.8%
 
14601690.8%
 
15801670.8%
 
16101660.8%
 
18001660.8%
 
17201660.8%
 
16201650.8%
 
Other values (767)1984991.8%
 
ValueCountFrequency (%) 
3991< 0.1%
 
4602< 0.1%
 
6202< 0.1%
 
6701< 0.1%
 
6902< 0.1%
 
ValueCountFrequency (%) 
62101< 0.1%
 
61101< 0.1%
 
57906< 0.1%
 
56101< 0.1%
 
56001< 0.1%
 

sqft_lot15
Real number (ℝ≥0)

Distinct count8689
Unique (%)40.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12768.455651691113
Minimum651
Maximum871200
Zeros0
Zeros (%)0.0%
Memory size168.9 KiB

Quantile statistics

Minimum651
5-th percentile1999.2
Q15100
median7620
Q310083
95-th percentile37062.8
Maximum871200
Range870549
Interquartile range (IQR)4983

Descriptive statistics

Standard deviation27304.17963
Coefficient of variation (CV)2.138408933
Kurtosis150.76311
Mean12768.45565
Median Absolute Deviation (MAD)2505
Skewness9.506743247
Sum275964632
Variance745518225.3
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
50004272.0%
 
40003571.7%
 
60002891.3%
 
72002111.0%
 
48001450.7%
 
75001420.7%
 
84001160.5%
 
36001110.5%
 
45001110.5%
 
51001090.5%
 
Other values (8679)1959590.7%
 
ValueCountFrequency (%) 
6511< 0.1%
 
6591< 0.1%
 
6601< 0.1%
 
7482< 0.1%
 
7504< 0.1%
 
ValueCountFrequency (%) 
8712001< 0.1%
 
8581321< 0.1%
 
5606171< 0.1%
 
4382131< 0.1%
 
4347281< 0.1%
 

age
Real number (ℝ)

ZEROS

Distinct count117
Unique (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean43.31781797991949
Minimum-1
Maximum115
Zeros430
Zeros (%)2.0%
Memory size168.9 KiB

Quantile statistics

Minimum-1
5-th percentile4
Q118
median40
Q363
95-th percentile99
Maximum115
Range116
Interquartile range (IQR)45

Descriptive statistics

Standard deviation29.3754928
Coefficient of variation (CV)0.6781387931
Kurtosis-0.6579831918
Mean43.31781798
Median Absolute Deviation (MAD)23
Skewness0.4691624259
Sum936228
Variance862.9195775
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
94732.2%
 
84432.0%
 
114332.0%
 
04302.0%
 
104282.0%
 
74001.9%
 
373891.8%
 
363811.8%
 
473671.7%
 
463431.6%
 
Other values (107)1752681.1%
 
ValueCountFrequency (%) 
-1120.1%
 
04302.0%
 
12851.3%
 
21740.8%
 
31650.8%
 
ValueCountFrequency (%) 
115260.1%
 
114690.3%
 
113280.1%
 
112330.2%
 
111500.2%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

pricebedroomsbathroomssqft_livingsqft_lotfloorswaterfrontviewconditiongradesqft_abovesqft_basementlatlongsqft_living15sqft_lot15age
0221900.031.00118056501.000371180047.5112-122.2571340565059
1538000.032.25257072422.00037217040047.7210-122.3191690763963
2180000.021.00770100001.00036770047.7379-122.2332720806282
3604000.043.00196050001.00057105091047.5208-122.3931360500049
4510000.032.00168080801.000381680047.6168-122.0451800750328
51225000.044.5054201019301.0003113890153047.6561-122.005476010193013
6257500.032.25171568192.000371715047.3097-122.3272238681919
7291850.031.50106097111.000371060047.4095-122.3151650971152
8229500.031.00178074701.00037105073047.5123-122.3371780811355
9323000.032.50189065602.000371890047.3684-122.0312390757012

Last rows

pricebedroomsbathroomssqft_livingsqft_lotfloorswaterfrontviewconditiongradesqft_abovesqft_basementlatlongsqft_living15sqft_lot15age
21603507250.032.50227055362.000382270047.5389-121.8812270573111
21604429000.032.00149011263.000381490047.5699-122.288140012301
21605610685.042.50252060232.000392520047.5137-122.167252060230
216061007500.043.50351072002.00039260091047.5537-122.398205062006
21607475000.032.50131012942.00038118013047.5773-122.409133012657
21608360000.032.50153011313.000381530047.6993-122.346153015095
21609400000.042.50231058132.000382310047.5107-122.362183072001
21610402101.020.75102013502.000371020047.5944-122.299102020075
21611400000.032.50160023882.000381600047.5345-122.0691410128711
21612325000.020.75102010762.000371020047.5941-122.299102013576

Duplicate rows

Most frequent

pricebedroomsbathroomssqft_livingsqft_lotfloorswaterfrontviewconditiongradesqft_abovesqft_basementlatlongsqft_living15sqft_lot15agecount
0259950.022.0010706492.0003972035047.5213-122.357107092872
1529500.032.2514109053.000391410047.5818-122.4021510135212
2550000.041.75241084472.00348206035047.6499-122.088252014789782
3555000.032.50194032112.000381940047.5644-122.0931880307852
4635000.033.00223014072.50038185038047.5446-122.0172290140712